You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Zahra Zahid <za...@gmail.com> on 2004/09/29 15:31:51 UTC

Schema does not exits exception

Hi all,
   This is the connection im using in my build.properties files....the
database gets made but when some specific objects are 2 be loaded an
exception is thrown:
database=derby
dbDialect=net.sf.hibernate.dialect.GenericDialect
jdbcDriver=derby.jar
dbURL=jdbc:derby:omar_registry;create=true;user=omar;password=omar
 
dbUsername=omar
dbPassword=omar
jdbcClassName=org.apache.derby.jdbc.EmbeddedDriver
dbTransactionIsolation=TRANSACTION_READ_COMMITTED
dbLargeBinaryType=blob

I need to know how to resolve this issue?

////////////****exception thrown is as below****\\\\\\\\\\\\\\\\


runSOAPSender:
     [java] <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
     [java] <soap-env:Envelope
     [java]     xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
     [java]     xmlns:SOAP-SEC="http://schemas.xmlsoap.org/soap/security/2000-12
" soap-env:actor="some-uri"
     [java]     soap-env:mustUnderstand="1">

     [java]     <soap-env:Header>
     [java]     </soap-env:Header>

     [java]     <soap-env:Body SOAP-SEC:id="Body">

     [java] <RegistryResponse status="urn:uuid:db2127df-e8d0-4e43-8d80-8eee6962e
f64" xmlns="urn:oasis:names:tc:ebxml-regrep:xsd:rs:3.0">
     [java]     <RegistryErrorList>
     [java]         <RegistryError codeContext="RegistryJAXMServlet" errorCode="
Unknown">org.freebxml.omar.common.RegistryException: SQL Exception: Schema 'OMAR
' does not exist
     [java]     at org.freebxml.omar.server.persistence.rdb.SQLPersistenceManage
rImpl.executeSQLQuery(SQLPersistenceManagerImpl.java:1025)
     [java]     at org.freebxml.omar.server.security.authentication.Authenticati
onServiceImpl.getUserFromAlias(AuthenticationServiceImpl.java:371)
     [java]     at org.freebxml.omar.server.security.authentication.Authenticati
onServiceImpl.getUserFromCertificate(AuthenticationServiceImpl.java:602)
     [java]     at org.freebxml.omar.server.security.authentication.Authenticati
onServiceImpl.getUserFromXMLSignature(AuthenticationServiceImpl.java:562)
     [java]     at org.freebxml.omar.server.interfaces.Request.process(Request.j
ava:107)

                 thanx
                          regards
                             Zahra Zahid

Re: Schema does not exits exception

Posted by Suresh Thalamati <ts...@Source-Zone.org>.
Zahra Zahid wrote:

>Ok i added the values in derby.properties file ...n placed it at
>C:/DERBY/TRUNK....here how my properties file lookssss....
>derby.system.home =C:\derby\trunk
>
>  
>
I think derby.system.home =C:/derby/trunk should be specified with -D
option or
as environment variable in the application. It can not be in the
derby.properties for sure.
If  you are using derby embedded through another application ,
typicallly it will have
property to specify derby home.

Derby looks for the properties file in derby.system.home location ,  if
you don't specify it will default to
the  JVM default directory.  It will be same location where derby.log
also will be created.


-suresht


Re: Schema does not exits exception

Posted by Zahra Zahid <za...@gmail.com>.
Daniel!
  herez the complete stack trace of the application!!! i hope seeing
it wud help u identify watz the problem..
Thanx a lot for the help.
..(im attachin the output in a file 2 )

2004-12-02 11:29:40,566 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-02 11:29:40,566 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-02 11:29:40,576 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-02 11:29:40,576 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-02 11:29:40,596 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-02 11:29:40,596 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-02 11:29:40,606 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:29:40,606 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:29:40,616 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-02 11:29:40,616 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-02 11:29:40,626 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-02 11:29:40,626 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-02 11:29:40,646 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-02 11:29:40,646 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-02 11:29:40,656 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:29:40,656 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:29:44,972 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-02 11:29:44,972 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-02 11:29:44,982 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-02 11:29:44,992 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-02 11:29:45,082 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - drop table
RepositoryItem
2004-12-02 11:29:45,102 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Unsuccessful: drop
table RepositoryItem
2004-12-02 11:29:45,102 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - ERROR: table
"repositoryitem" does not exist
2004-12-02 11:29:45,102 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
complete
2004-12-02 11:29:45,122 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-02 11:29:45,122 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-02 11:29:45,193 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - drop table
RepositoryItem
2004-12-02 11:29:45,193 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Unsuccessful: drop
table RepositoryItem
2004-12-02 11:29:45,203 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - ERROR: table
"repositoryitem" does not exist
2004-12-02 11:29:45,203 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - create table
RepositoryItem (
   lid VARCHAR(128) not null,
   versionName VARCHAR(16) not null,
   content BYTEA,
   signature BYTEA,
   primary key (lid, versionName)
)
2004-12-02 11:29:45,273 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
complete
2004-12-02 11:29:45,273 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-02 11:29:45,273 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-02 11:35:51,980 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-02 11:35:51,980 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-02 11:35:51,980 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-02 11:35:51,980 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-02 11:35:51,990 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-02 11:35:51,990 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-02 11:35:51,990 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:35:51,990 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:35:52,000 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-02 11:35:52,000 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-02 11:35:52,000 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-02 11:35:52,000 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-02 11:35:52,010 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-02 11:35:52,010 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-02 11:35:52,020 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:35:52,020 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-02 11:35:56,597 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-02 11:35:56,597 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-02 11:35:56,617 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-02 11:35:56,617 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-02 11:35:56,727 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - drop table
RepositoryItem
2004-12-02 11:35:56,747 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Unsuccessful: drop
table RepositoryItem
2004-12-02 11:35:56,747 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - ERROR: table
"repositoryitem" does not exist
2004-12-02 11:35:56,747 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
complete
2004-12-02 11:35:56,767 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-02 11:35:56,767 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-02 11:35:56,837 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - drop table
RepositoryItem
2004-12-02 11:35:56,837 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Unsuccessful: drop
table RepositoryItem
2004-12-02 11:35:56,847 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - ERROR: table
"repositoryitem" does not exist
2004-12-02 11:35:56,847 DEBUG
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - create table
RepositoryItem (
   lid VARCHAR(128) not null,
   versionName VARCHAR(16) not null,
   content BYTEA,
   signature BYTEA,
   primary key (lid, versionName)
)
2004-12-02 11:35:56,917 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
complete
2004-12-02 11:35:56,917 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-02 11:35:56,917 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 12:40:14,294 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 12:40:14,294 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 12:40:14,314 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 12:40:14,314 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 12:40:14,314 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 12:40:14,314 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 12:40:14,324 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:40:14,324 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:40:14,334 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 12:40:14,334 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 12:40:14,334 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 12:40:14,334 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 12:40:14,344 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 12:40:14,344 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 12:40:14,344 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:40:14,344 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:40:21,644 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 12:40:21,644 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 12:40:21,664 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 12:40:21,664 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 12:40:21,694 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 12:40:21,734 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 12:40:21,734 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 12:40:21,754 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 12:40:21,814 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 12:40:21,814 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 12:47:21,107 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 12:47:21,107 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 12:47:21,107 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 12:47:21,107 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 12:47:21,117 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 12:47:21,117 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 12:47:21,137 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:47:21,137 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:47:21,137 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 12:47:21,137 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 12:47:21,147 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 12:47:21,147 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 12:47:21,157 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 12:47:21,157 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 12:47:21,167 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:47:21,167 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 12:47:28,228 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 12:47:28,228 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 12:47:28,408 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 12:47:28,408 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 12:47:28,548 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 12:47:28,588 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 12:47:28,588 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 12:47:28,618 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 12:47:28,889 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 12:47:28,889 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 13:00:17,834 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 13:00:17,834 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-04 13:00:17,844 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 13:00:17,844 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-04 13:00:17,844 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 13:00:17,844 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 13:00:17,854 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-04 13:00:17,864 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 13:00:17,864 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-04 13:00:17,874 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 13:00:17,874 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-04 13:00:24,404 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 13:00:24,404 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-04 13:00:24,434 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 13:00:24,434 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 13:00:24,494 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 13:00:24,564 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-04 13:00:24,564 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-04 13:00:24,624 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-04 13:00:24,664 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-04 13:00:24,664 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 15:31:59,864 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 15:31:59,864 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 15:31:59,874 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 15:31:59,874 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 15:31:59,884 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 15:31:59,884 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 15:31:59,894 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 15:31:59,894 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 15:31:59,894 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 15:31:59,894 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 15:31:59,904 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 15:31:59,904 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 15:31:59,904 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 15:31:59,904 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 15:31:59,914 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 15:31:59,914 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 15:32:05,652 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 15:32:05,652 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 15:32:05,663 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 15:32:05,673 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 15:32:05,713 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'C:/omar', see the next
exception for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 15:32:05,753 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 15:32:05,753 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 15:32:05,773 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'C:/omar', see the next
exception for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 15:32:05,803 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 15:32:05,803 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 16:21:49,143 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 16:21:49,143 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 16:21:49,173 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 16:21:49,173 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 16:21:49,183 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 16:21:49,183 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 16:21:49,203 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 16:21:49,203 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 16:21:49,213 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 16:21:49,213 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 16:21:49,223 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 16:21:49,223 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 16:21:49,253 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 16:21:49,253 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 16:21:49,263 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 16:21:49,263 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 16:21:55,592 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 16:21:55,592 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 16:21:55,612 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 16:21:55,622 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 16:21:55,662 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'C:/omar', see the next
exception for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 16:21:55,702 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 16:21:55,702 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 16:21:55,712 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'C:/omar', see the next
exception for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 16:21:55,752 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 16:21:55,752 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 18:43:19,467 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 18:43:19,467 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 18:43:19,477 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 18:43:19,477 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 18:43:19,487 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 18:43:19,487 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 18:43:19,497 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 18:43:19,507 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 18:43:19,507 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 18:43:19,517 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 18:43:19,517 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 18:43:26,256 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 18:43:26,256 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 18:43:26,276 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 18:43:26,286 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 18:43:26,306 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 18:43:26,377 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 18:43:26,387 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 18:43:26,397 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 18:43:26,447 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 18:43:26,447 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 19:07:28,891 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 19:07:28,891 INFO org.freebxml.omar.common.Properties[main]
- Loading omar-common properties..
2004-12-11 19:07:28,901 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 19:07:28,901 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/common/omar-common-defaults.properties
2004-12-11 19:07:28,921 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 19:07:28,921 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar-common.properties
2004-12-11 19:07:28,931 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 19:07:28,931 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 19:07:28,941 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 19:07:28,941 INFO org.freebxml.omar.common.Properties[main]
- Loading omar properties..
2004-12-11 19:07:28,951 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 19:07:28,951 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath:
org/freebxml/omar/server/common/omar-defaults.properties
2004-12-11 19:07:29,001 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 19:07:29,001 INFO org.freebxml.omar.common.Properties[main]
- Load props from classpath: omar.properties
2004-12-11 19:07:29,011 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 19:07:29,011 INFO org.freebxml.omar.common.Properties[main]
- Load props from system props.
2004-12-11 19:07:34,679 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 19:07:34,679 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- --- Rebuilding DB schema ---
2004-12-11 19:07:34,719 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 19:07:34,729 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 19:07:34,749 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.drop(SchemaExport.java:93)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:203)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 19:07:34,939 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - Running hbm2ddl
schema export
2004-12-11 19:07:34,939 INFO
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - exporting generated
schema to database
2004-12-11 19:07:34,959 ERROR
net.sf.hibernate.tool.hbm2ddl.SchemaExport[main] - schema export
unsuccessful
SQL Exception: Failed to start database 'omar', see the next exception
for details.
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java)
	at org.apache.derby.impl.jdbc.EmbedConnection20.<init>(EmbedConnection20.java)
	at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(EmbedConnection30.java)
	at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java)
	at org.apache.derby.jdbc.Driver169.connect(Driver169.java)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
	at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.createDB(RepositoryHibernateUtil.java:206)
	at org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil.initDB(RepositoryHibernateUtil.java:173)
	at org.freebxml.omar.server.repository.hibernate.RepositoryHibernateUtil.main(RepositoryHibernateUtil.java:118)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:324)
	at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:193)
	at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:130)
	at org.apache.tools.ant.taskdefs.Java.run(Java.java:705)
	at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:177)
	at org.apache.tools.ant.taskdefs.Java.execute(Java.java:83)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:386)
	at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:106)
	at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
	at org.apache.tools.ant.Task.perform(Task.java:364)
	at org.apache.tools.ant.Target.execute(Target.java:341)
	at org.apache.tools.ant.Target.performTasks(Target.java:369)
	at org.apache.tools.ant.Project.executeTarget(Project.java:1214)
	at org.apache.tools.ant.Project.executeTargets(Project.java:1062)
	at org.apache.tools.ant.Main.runBuild(Main.java:673)
	at org.apache.tools.ant.Main.startAnt(Main.java:188)
	at org.apache.tools.ant.Main.start(Main.java:151)
	at org.apache.tools.ant.Main.main(Main.java:241)
2004-12-11 19:07:35,130 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created
2004-12-11 19:07:35,130 INFO
org.freebxml.omar.server.repository.hibernate.AbstractHibernateUtil[main]
- Database created

Re: Schema does not exits exception

Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Zahra Zahid wrote:
> Yep its there ..but still i get the same exception n it doesnt show in
> the Derby.log ...i donno whatz wrong :s
> .has anyone used user authentication???
> if any1 has plz let me know the wht your derby.properties look like...

I don't think your 'schema not found' exception is related to
authentication. A SQL statement (most likely a DROP or a SELECT) is
trying to access schema OMAR before it is created. Authentication does
not create schemas.

http://nagoya.apache.org/eyebrowse/ReadMsg?listName=derby-user@db.apache.org&msgNo=106

http://nagoya.apache.org/eyebrowse/ReadMsg?listName=derby-user@db.apache.org&msgNo=112

Getting your application to print out the stack trace of the
SQLException chain being thrown from Derby's JDBC driver would be a
great help.

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBuxjAIv0S4qsbfuQRAhLuAJ9jX01z4gke9iMUVIMo2DF4S775wgCgz/2n
A9sCS5+Kx7hUrog4wGauEXc=
=p/MM
-----END PGP SIGNATURE-----


Re: Schema does not exits exception

Posted by Zahra Zahid <za...@gmail.com>.
Yep its there ..but still i get the same exception n it doesnt show in
the Derby.log ...i donno whatz wrong :s
.has anyone used user authentication???
if any1 has plz let me know the wht your derby.properties look like... 

On Sat, 11 Dec 2004 05:52:09 -0800, myrnap <my...@golux.com> wrote:
> Hi,
> 
> The derby.properties file needs to be in the dir where you start your
> 'java' command. Should be the same place where your derby.log shows up now.
> 
> Myrna
> 
> 
> 
> Zahra Zahid wrote:
> 
> >Ok i added the values in derby.properties file ...n placed it at
> >C:/DERBY/TRUNK....here how my properties file lookssss....
> >derby.system.home =C:\derby\trunk
> >derby.connection.requireAuthentication=true
> >derby.user.omar=omar
> >derby.stream.error.logSeverityLevel=0
> >
> >derby.language.logStatementText=true
> >
> >I am still getting the same!!! OMAR schema not found...but it doesnt
> >show in derby.log file ....
> >Am i placing the cerby.properties file in the rite place...
> >or shud i place it wid in the application!!! i.e. OMAR!!!
> >
> >                                      regards
> >                                          Zahra
> >
> >
> >
> >
> >>Derby doesn't have a CREATE USER command and its built-in user support
> >>is only for authentication, it does not affect schema creation. If you
> >>are using CREATE SCHEMA OMAR in the database just created and you are
> >>still seeing the no such schema exception then it would be a bug.
> >>
> >>The best approach is to set this property so that all errors are
> >>reported to the derby.log file.
> >>derby.stream.error.logSeverityLevel=0
> >>
> >>The log file should include a stack trace of what is failing.
> >>
> >>Adding this property might also help in seeing what SQL statement is
> >>causing the problem.
> >>derby.language.logStatementText=true
> >>
> >>These would be set by either adding these two lines to the
> >>derby.properties file (create one if needed)
> >>
> >>derby.stream.error.logSeverityLevel=0
> >>derby.language.logStatementText=true
> >>
> >>or starting the JVM with these two additional arguments
> >>- -Dderby.language.logStatementText=true
> >>- -Dderby.stream.error.logSeverityLevel=0
> >>
> >>Dan.
> >>-----BEGIN PGP SIGNATURE-----
> >>Version: GnuPG v1.2.5 (MingW32)
> >>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> >>
> >>iD8DBQFBXASdIv0S4qsbfuQRArQgAKDT/PxeVzLKzSFQwQsqAwIAMl28ngCfcwME
> >>LsdWXEUDPirztZEZrpYLms0=
> >>=sr8V
> >>-----END PGP SIGNATURE-----
> >>
> >>
> >>
> >>
> >
> >
> >
> 
>

Re: Schema does not exits exception

Posted by myrnap <my...@Golux.Com>.
Hi,

The derby.properties file needs to be in the dir where you start your 
'java' command. Should be the same place where your derby.log shows up now.

Myrna

Zahra Zahid wrote:

>Ok i added the values in derby.properties file ...n placed it at
>C:/DERBY/TRUNK....here how my properties file lookssss....
>derby.system.home =C:\derby\trunk
>derby.connection.requireAuthentication=true
>derby.user.omar=omar
>derby.stream.error.logSeverityLevel=0
>
>derby.language.logStatementText=true
>
>I am still getting the same!!! OMAR schema not found...but it doesnt
>show in derby.log file ....
>Am i placing the cerby.properties file in the rite place...
>or shud i place it wid in the application!!! i.e. OMAR!!!
>
>                                      regards
>                                          Zahra
>
>
>  
>
>>Derby doesn't have a CREATE USER command and its built-in user support
>>is only for authentication, it does not affect schema creation. If you
>>are using CREATE SCHEMA OMAR in the database just created and you are
>>still seeing the no such schema exception then it would be a bug.
>>
>>The best approach is to set this property so that all errors are
>>reported to the derby.log file.
>>derby.stream.error.logSeverityLevel=0
>>
>>The log file should include a stack trace of what is failing.
>>
>>Adding this property might also help in seeing what SQL statement is
>>causing the problem.
>>derby.language.logStatementText=true
>>
>>These would be set by either adding these two lines to the
>>derby.properties file (create one if needed)
>>
>>derby.stream.error.logSeverityLevel=0
>>derby.language.logStatementText=true
>>
>>or starting the JVM with these two additional arguments
>>- -Dderby.language.logStatementText=true
>>- -Dderby.stream.error.logSeverityLevel=0
>>
>>Dan.
>>-----BEGIN PGP SIGNATURE-----
>>Version: GnuPG v1.2.5 (MingW32)
>>Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>>iD8DBQFBXASdIv0S4qsbfuQRArQgAKDT/PxeVzLKzSFQwQsqAwIAMl28ngCfcwME
>>LsdWXEUDPirztZEZrpYLms0=
>>=sr8V
>>-----END PGP SIGNATURE-----
>>
>>
>>    
>>
>
>  
>


Re: Schema does not exits exception

Posted by Zahra Zahid <za...@gmail.com>.
Ok i added the values in derby.properties file ...n placed it at
C:/DERBY/TRUNK....here how my properties file lookssss....
derby.system.home =C:\derby\trunk
derby.connection.requireAuthentication=true
derby.user.omar=omar
derby.stream.error.logSeverityLevel=0

derby.language.logStatementText=true

I am still getting the same!!! OMAR schema not found...but it doesnt
show in derby.log file ....
Am i placing the cerby.properties file in the rite place...
or shud i place it wid in the application!!! i.e. OMAR!!!

                                      regards
                                          Zahra


> Derby doesn't have a CREATE USER command and its built-in user support
> is only for authentication, it does not affect schema creation. If you
> are using CREATE SCHEMA OMAR in the database just created and you are
> still seeing the no such schema exception then it would be a bug.
> 
> The best approach is to set this property so that all errors are
> reported to the derby.log file.
> derby.stream.error.logSeverityLevel=0
> 
> The log file should include a stack trace of what is failing.
> 
> Adding this property might also help in seeing what SQL statement is
> causing the problem.
> derby.language.logStatementText=true
> 
> These would be set by either adding these two lines to the
> derby.properties file (create one if needed)
> 
> derby.stream.error.logSeverityLevel=0
> derby.language.logStatementText=true
> 
> or starting the JVM with these two additional arguments
> - -Dderby.language.logStatementText=true
> - -Dderby.stream.error.logSeverityLevel=0
> 
> Dan.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.5 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFBXASdIv0S4qsbfuQRArQgAKDT/PxeVzLKzSFQwQsqAwIAMl28ngCfcwME
> LsdWXEUDPirztZEZrpYLms0=
> =sr8V
> -----END PGP SIGNATURE-----
> 
>

Re: Schema does not exits exception

Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Zahra Zahid wrote:

> I dont think the problem is with the application accessing the
> tables..becuase it works fine with postgres.
> When i used to make a database in postgres...i wud also use the CREATE
> USER omar with password 'omar';
> command to make a user omar.
> How do i do this in Derby...because i think this can help me get the
> schema not found exception out...i have tried to make a schema within
> the database myself but still i get the same exception.
> How do u make a new user in derby system?


Derby doesn't have a CREATE USER command and its built-in user support
is only for authentication, it does not affect schema creation. If you
are using CREATE SCHEMA OMAR in the database just created and you are
still seeing the no such schema exception then it would be a bug.

The best approach is to set this property so that all errors are
reported to the derby.log file.
derby.stream.error.logSeverityLevel=0

The log file should include a stack trace of what is failing.

Adding this property might also help in seeing what SQL statement is
causing the problem.
derby.language.logStatementText=true

These would be set by either adding these two lines to the
derby.properties file (create one if needed)

derby.stream.error.logSeverityLevel=0
derby.language.logStatementText=true

or starting the JVM with these two additional arguments
- -Dderby.language.logStatementText=true
- -Dderby.stream.error.logSeverityLevel=0

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBXASdIv0S4qsbfuQRArQgAKDT/PxeVzLKzSFQwQsqAwIAMl28ngCfcwME
LsdWXEUDPirztZEZrpYLms0=
=sr8V
-----END PGP SIGNATURE-----


Re: Schema does not exits exception

Posted by Zahra Zahid <za...@gmail.com>.
I dont think the problem is with the application accessing the
tables..becuase it works fine with postgres.
When i used to make a database in postgres...i wud also use the CREATE
USER omar with password 'omar';
command to make a user omar.
How do i do this in Derby...because i think this can help me get the
schema not found exception out...i have tried to make a schema within
the database myself but still i get the same exception.
How do u make a new user in derby system? 
 
 


On Wed, 29 Sep 2004 07:50:01 -0700, Daniel John Debrunner
<dj...@debrunners.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Zahra Zahid wrote:
> 
> > Hi all,
> >    This is the connection im using in my build.properties files....the
> > database gets made but when some specific objects are 2 be loaded an
> > exception is thrown:
> > database=derby
> > dbDialect=net.sf.hibernate.dialect.GenericDialect
> > jdbcDriver=derby.jar
> > dbURL=jdbc:derby:omar_registry;create=true;user=omar;password=omar
> >
> > dbUsername=omar
> > dbPassword=omar
> > jdbcClassName=org.apache.derby.jdbc.EmbeddedDriver
> > dbTransactionIsolation=TRANSACTION_READ_COMMITTED
> > dbLargeBinaryType=blob
> >
> > I need to know how to resolve this issue?
> 
> It's hard to see what is going on, namely what SQL statement is causing
> the schema not found execption. But maybe an explanation will help.
> 
> The current schema for any connection defaults to a schema corresponding
> to the user name, in this case OMAR. If no user name is supplied then
> the user name (and hence current schema) defaults to APP.
> 
> However even though the current schema is set to the user name, that
> schema may not exist. A schema is only created by CREATE SCHEMA or
> creating an object (table etc.) in that schema (this is implicit schema
> creation). Thus in your case the schema OMAR does not exist.
> 
> The one exception to this is the APP schema, which is always created,
> though applications should not depend on that.
> 
> So you will see the schema not exists error if your application tries to
> access the current schema before any objects have been created in it.
> Possibilities are you try to perform a DROP TABLE before creating it, or
> try to SELECT from a table to see if it should be created or not.
> 
> Dan.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.5 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFBWsuYIv0S4qsbfuQRAtzWAJ0aV0tTB8Kow0kIW6hEilSa0lIVmwCg0pRD
> ulxNnc92dgt/mgU+fnOkMWw=
> =/bcK
> -----END PGP SIGNATURE-----
> 
>

Re: Schema does not exits exception

Posted by Daniel John Debrunner <dj...@debrunners.com>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Zahra Zahid wrote:

> Hi all,
>    This is the connection im using in my build.properties files....the
> database gets made but when some specific objects are 2 be loaded an
> exception is thrown:
> database=derby
> dbDialect=net.sf.hibernate.dialect.GenericDialect
> jdbcDriver=derby.jar
> dbURL=jdbc:derby:omar_registry;create=true;user=omar;password=omar
>
> dbUsername=omar
> dbPassword=omar
> jdbcClassName=org.apache.derby.jdbc.EmbeddedDriver
> dbTransactionIsolation=TRANSACTION_READ_COMMITTED
> dbLargeBinaryType=blob
>
> I need to know how to resolve this issue?

It's hard to see what is going on, namely what SQL statement is causing
the schema not found execption. But maybe an explanation will help.

The current schema for any connection defaults to a schema corresponding
to the user name, in this case OMAR. If no user name is supplied then
the user name (and hence current schema) defaults to APP.

However even though the current schema is set to the user name, that
schema may not exist. A schema is only created by CREATE SCHEMA or
creating an object (table etc.) in that schema (this is implicit schema
creation). Thus in your case the schema OMAR does not exist.

The one exception to this is the APP schema, which is always created,
though applications should not depend on that.

So you will see the schema not exists error if your application tries to
access the current schema before any objects have been created in it.
Possibilities are you try to perform a DROP TABLE before creating it, or
try to SELECT from a table to see if it should be created or not.

Dan.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFBWsuYIv0S4qsbfuQRAtzWAJ0aV0tTB8Kow0kIW6hEilSa0lIVmwCg0pRD
ulxNnc92dgt/mgU+fnOkMWw=
=/bcK
-----END PGP SIGNATURE-----