Error on opening database: the engine 'remote' was not found

Thanks for your helps.

I 'm using orientDB 2.2.37.(orientdb-community-importers-2.2.37)
Java is SUN JDK 1.7.

Now I’m testing jdbc datasource for orientDB 2.2.37

  1. Server Start --> OK
    OrientDB server successfully have started.

  2. Connect Server using Console --> OK
    and then
    I want to access to test database(GratefulDeadConcerts), using console.

Connecting Server was succesed.

  1. JDBC Test Spring Bean XML

and then I want to access database(GratefulDeadConcerts), using Spring Jdbc datasource.

My Spring bean was following :

=======================================

<bean id="dataSource" class="com.orientechnologies.orient.jdbc.OrientDataSource">

	<property name="url" value="jdbc:orient:remote:localhost/GratefulDeadConcerts"/>

    <property name="username" value="root"/>
    <property name="password" value="sogom0304"/>
	<property name="info" ref="databaseProperties"/>
	
</bean>

=======================================

But. I cannot access to database(GratefulDeadConcerts). using jdbc datasoure.

Server was return Error Meassage:

=======================================

2019-08-08 09:47:18,570 | ERROR | l Console Thread | JdbcServiceImpl | 74 - bada-jdbc-core - 1.2.0 | 데이타 소스에 대한 정보를 얻을 수 없습니다. 587
com.orientechnologies.orient.core.exception.ODatabaseException: Error on opening database ‘remote:localhost/GratefulDeadConcerts’
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.(ODatabaseDocumentTx.java:193)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool$DatabaseDocumentTxPooled.(OPartitionedDatabasePool.java:428)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool$DatabaseDocumentTxPooled.(OPartitionedDatabasePool.java:424)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.initQueue(OPartitionedDatabasePool.java:358)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.(OPartitionedDatabasePool.java:117)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePoolFactory.get(OPartitionedDatabasePoolFactory.java:116)
at com.orientechnologies.orient.jdbc.OrientJdbcConnection.(OrientJdbcConnection.java:59)
at com.orientechnologies.orient.jdbc.OrientJdbcDriver.connect(OrientJdbcDriver.java:60)
at java.sql.DriverManager.getConnection(DriverManager.java:571)[:1.7.0_75]
at java.sql.DriverManager.getConnection(DriverManager.java:187)[:1.7.0_75]
at com.orientechnologies.orient.jdbc.OrientDataSource.getConnection(OrientDataSource.java:103)
at com.orientechnologies.orient.jdbc.OrientDataSource.getConnection(OrientDataSource.java:94)
at kr.co.sogomsoft.bada.jdbc.core.internal.JdbcServiceImpl.info(JdbcServiceImpl.java:562)
at Proxy9730a050_b67e_41e2_9783_40a552292cc5.info(Unknown Source)
at kr.co.sogomsoft.bada.jdbc.commands.DataSourcesCommand.doExecute(DataSourcesCommand.java:76)
at kr.co.sogomsoft.bada.shell.console.OsgiCommandSupport.execute(OsgiCommandSupport.java:69)
at kr.co.sogomsoft.bada.felix.gogo.commands.basic.AbstractCommand.execute(AbstractCommand.java:58)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.7.0_75]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.7.0_75]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606)[:1.7.0_75]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:54)[15:org.apache.aries.proxy.impl:1.0.4]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:119)[15:org.apache.aries.proxy.impl:1.0.4]
at kr.co.sogomsoft.bada.shell.console.commands.$BlueprintCommand694798305.execute(Unknown Source)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:78)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:477)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:403)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Pipe.run(Pipe.java:108)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:183)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:120)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.CommandSessionImpl.execute(CommandSessionImpl.java:92)[25:bada-shell-console:1.2.0]
at kr.co.sogomsoft.bada.shell.console.jline.Console.run(Console.java:346)[25:bada-shell-console:1.2.0]
at kr.co.sogomsoft.bada.shell.console.jline.DelayedStarted.run(DelayedStarted.java:126)[25:bada-shell-console:1.2.0]
Caused by: com.orientechnologies.orient.core.exception.OConfigurationException: Error on opening database: the engine ‘remote’ was not found. URL was: remote:localhost/GratefulDeadConcerts. Registered engines are: [plocal, memory]
DB name=“remote:localhost/GratefulDeadConcerts”
at com.orientechnologies.orient.core.Orient.loadStorage(Orient.java:519)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.(ODatabaseDocumentTx.java:173)
… 32 more

=======================================

Please Help me?

Am I change another point, such as, config xml, datasource url. the Others?

Hi @dewey94

did you include orientdb-client in your pom.xml?

Hi wolf4ood

Thank for your answer.

I have included java library

My Test Server is based on OSGi Server
and I am installed Bundle (add jar for bundle)

@dewey94

are you producing a single jar as deploy?

@wolf4ood

No.

For regular Java processors, add jar to lib folder. or add POM.xml
For OSGi-based, deploy as individual bundles and jars are shared within the server.

They are all used in the same way. such as Oracle JDBC jar, PostgresSQL JDBC jar, MS-SQL JDBC jar.

@dewey94

check this link, it could be a problem of services

https://orientdb.com/docs/last/Tutorial-Installation.html#building-a-single-executable-jar-with-orientdb

Thanks

@wolf4ood

Thanks for your help.

I will check your advice, and I will apply My Server.

I hope that my problem will have fixed.

@wolf4ood

My Problem does not fix.

I made a single executable jar follow image:

but It also occurs Exception

2019-08-14 11:02:46,412 | ERROR | l Console Thread | JdbcServiceImpl | 74 - bada-jdbc-core - 1.2.0 | 데이타 소스에 대한 정보를 얻을 수 없습니다. 1139
com.orientechnologies.orient.core.exception.ODatabaseException: Error on opening database ‘remote:localhost/GratefulDeadConcerts’
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.(ODatabaseDocumentTx.java:193)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool$DatabaseDocumentTxPooled.(OPartitionedDatabasePool.java:428)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool$DatabaseDocumentTxPooled.(OPartitionedDatabasePool.java:424)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.initQueue(OPartitionedDatabasePool.java:358)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePool.(OPartitionedDatabasePool.java:117)
at com.orientechnologies.orient.core.db.OPartitionedDatabasePoolFactory.get(OPartitionedDatabasePoolFactory.java:116)
at com.orientechnologies.orient.jdbc.OrientJdbcConnection.(OrientJdbcConnection.java:59)
at com.orientechnologies.orient.jdbc.OrientJdbcDriver.connect(OrientJdbcDriver.java:60)
at java.sql.DriverManager.getConnection(DriverManager.java:571)[:1.7.0_75]
at java.sql.DriverManager.getConnection(DriverManager.java:187)[:1.7.0_75]
at com.orientechnologies.orient.jdbc.OrientDataSource.getConnection(OrientDataSource.java:103)
at com.orientechnologies.orient.jdbc.OrientDataSource.getConnection(OrientDataSource.java:94)
at kr.co.sogomsoft.bada.jdbc.core.internal.JdbcServiceImpl.info(JdbcServiceImpl.java:562)
at Proxy3159b071_d3ea_498e_b829_c978ab461112.info(Unknown Source)
at kr.co.sogomsoft.bada.jdbc.commands.DataSourcesCommand.doExecute(DataSourcesCommand.java:76)
at kr.co.sogomsoft.bada.shell.console.OsgiCommandSupport.execute(OsgiCommandSupport.java:69)
at kr.co.sogomsoft.bada.felix.gogo.commands.basic.AbstractCommand.execute(AbstractCommand.java:58)
at sun.reflect.GeneratedMethodAccessor157.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_75]
at java.lang.reflect.Method.invoke(Method.java:606)[:1.7.0_75]
at org.apache.aries.proxy.impl.ProxyHandler$1.invoke(ProxyHandler.java:54)[15:org.apache.aries.proxy.impl:1.0.4]
at org.apache.aries.proxy.impl.ProxyHandler.invoke(ProxyHandler.java:119)[15:org.apache.aries.proxy.impl:1.0.4]
at kr.co.sogomsoft.bada.shell.console.commands.$BlueprintCommand1203266067.execute(Unknown Source)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.CommandProxy.execute(CommandProxy.java:78)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.executeCmd(Closure.java:477)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.executeStatement(Closure.java:403)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Pipe.run(Pipe.java:108)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:183)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.Closure.execute(Closure.java:120)[25:bada-shell-console:1.2.0]
at org.apache.felix.gogo.runtime.CommandSessionImpl.execute(CommandSessionImpl.java:92)[25:bada-shell-console:1.2.0]
at kr.co.sogomsoft.bada.shell.console.jline.Console.run(Console.java:346)[25:bada-shell-console:1.2.0]
at kr.co.sogomsoft.bada.shell.console.jline.DelayedStarted.run(DelayedStarted.java:126)[25:bada-shell-console:1.2.0]
Caused by: com.orientechnologies.orient.core.exception.OConfigurationException: Error on opening database: the engine ‘remote’ was not found. URL was: remote:localhost/GratefulDeadConcerts. Registered engines are: []
DB name=“remote:localhost/GratefulDeadConcerts”
at com.orientechnologies.orient.core.Orient.loadStorage(Orient.java:519)
at com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx.(ODatabaseDocumentTx.java:173)
… 31 more

Plz.
Am I check another point?
or
Can I get another Document or URL for reference?