You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomee.apache.org by mikespan <mi...@netscape.net> on 2012/10/01 20:40:33 UTC
Getting a persistence exception using openjpa jta datasource
I'm getting the following exception when trying to persist data using a jta
configured data source
<openjpa-2.2.0-r422266:1244990 fatal general error>
org.apache.openjpa.persistence.PersistenceException: invalid authorization
specification - not found: root
My datasource is listed in tomee.xml
<Resource id="jdbc/mysql" type="javax.sql.DataSource">
# configure the pool
DataSourceCreator = tomcat
# it is a jta datasource
JtaManaged = true
# tomcat pool configuration
driverClassName = com.mysql.jdbc.Driver
url =
jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
username = root
password = *******
validationQuery = SELECT 1
maxActive=4
maxIdle=2
maxWait=-1
jmxEnabled = true # specific to tomcat pooling
</Resource>
My persistence.xml is
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
<persistence-unit name="analyticsPU" transaction-type="JTA">
<jta-data-source>jdbc/mysql</jta-data-source>
<properties>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(foreignKeys=true,schemaAction='dropDB,add')"/>
<property name="openjpa.jdbc.SchemaFactory"
value="native(foreignKeys=true)" />
<property name="openjpa.jdbc.MappingDefaults"
value="ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict"/>
<property name="openjpa.Log" value="DefaultLevel=TRACE,SQL=TRACE" />
</properties>
</persistence-unit>
</persistence>
My web.xml has
<persistence-unit-ref>
<persistence-unit-ref-name>persistence-factory</persistence-unit-ref-name>
<persistence-unit-name>analyticsPU</persistence-unit-name>
</persistence-unit-ref>
Code to create EntityManagerFactory
return (EntityManagerFactory) new
InitialContext().lookup("java:comp/env/persistence-factory");
Below is the log trace for openjpa when trying to open a connection
13776 analyticsPU INFO [http-bio-10080-exec-1] openjpa.Runtime -
Starting OpenJPA 2.2.0
13777 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime -
Properties: javax.persistence.lock.timeout: 0
javax.persistence.query.timeout: 0
javax.persistence.sharedCache.mode: UNSPECIFIED
javax.persistence.validation.group.pre-persist:
javax.validation.groups.Default
javax.persistence.validation.group.pre-update:
javax.validation.groups.Default
javax.persistence.validation.mode: AUTO
openjpa.AutoClear: 0
openjpa.AutoDetach: []
openjpa.BrokerFactory: jdbc
openjpa.BrokerImpl: non-finalizing
openjpa.CacheDistributionPolicy: default
openjpa.Callbacks: default
openjpa.ClassResolver:
org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
openjpa.Compatibility: default
openjpa.ConnectionFactoryMode: true
openjpa.ConnectionRetainMode: 0
openjpa.DataCache: false
openjpa.DataCacheManager: default
openjpa.DataCacheTimeout: -1
openjpa.DetachState: loaded
openjpa.DynamicDataStructs: false
openjpa.DynamicEnhancementAgent: true
openjpa.EntityManagerFactory: default
openjpa.FetchBatchSize: -1
openjpa.FetchGroups: [default]
openjpa.FlushBeforeQueries: 0
openjpa.Id: analyticsPU
openjpa.IgnoreChanges: false
openjpa.InitializeEagerly: false
openjpa.InstrumentationManager: default
openjpa.InverseManager: false
openjpa.LifecycleEventManager: validating
openjpa.LockManager: mixed
openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
openjpa.ManagedRuntime: auto
openjpa.MaxFetchDepth: -1
openjpa.MetaDataFactory:
jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
openjpa.MetaDataRepository: default
openjpa.Multithreaded: false
openjpa.NontransactionalRead: true
openjpa.NontransactionalWrite: true
openjpa.Optimistic: true
openjpa.OptimizeIdCopy: false
openjpa.OrphanedKeyAction: log
openjpa.PostLoadOnMerge: false
openjpa.ProxyManager: default
openjpa.QueryCache: false
openjpa.QueryCompilationCache: true
openjpa.ReadLockLevel: 10
openjpa.RefreshFromDataCache: false
openjpa.RestoreState: 1
openjpa.RetainState: true
openjpa.RetryClassRegistration: false
openjpa.RuntimeUnenhancedClasses: 0
openjpa.SavepointManager: in-mem
openjpa.Sequence: table
openjpa.TransactionMode: true
openjpa.WriteLockLevel: 20
openjpa.jdbc.DriverDataSource: auto
openjpa.jdbc.EagerFetchMode: 2
openjpa.jdbc.FetchDirection: 1000
openjpa.jdbc.FinderCache: true
openjpa.jdbc.IdentifierUtil: default
openjpa.jdbc.LRSSize: 2
openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict)
openjpa.jdbc.QuerySQLCache: true
openjpa.jdbc.ResultSetType: 1003
openjpa.jdbc.SQLFactory: default
openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
openjpa.jdbc.Schemas: []
openjpa.jdbc.SubclassFetchMode: 1
openjpa.jdbc.SynchronizeMappings:
buildSchema(foreignKeys=true,schemaAction='dropDB,add')
openjpa.jdbc.TransactionIsolation: -1
openjpa.jdbc.UpdateManager: default
13814 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
13903 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1da817b".
13907 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
13921 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
INFO: checkpointClose start
Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
INFO: checkpointClose end
14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1613fe7".
14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
14523 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
Oct 1, 2012 10:44:46 AM
com.adaptiveauth.rest.server.resources.InspectionResourceBase postInspection
INFO: <openjpa-2.2.0-r422266:1244990 fatal general error>
org.apache.openjpa.persistence.PersistenceException: invalid authorization
specification - not found: root
Don't know what kind of authorization is required for my user 'root' since
that user has all privileges on the database.
--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Getting a persistence exception using openjpa jta datasource
Posted by Romain Manni-Bucau <rm...@gmail.com>.
remove your comment (#xxx) and go to catalina part of the MBeans
you should find your datasource here
*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*
2012/10/1 mikespan <mi...@netscape.net>
> Can you provide a link to setup JMX monitoring for configuration. Tried
> looking but not sure the correct sample to use.
>
> Here is the complete log trace when a EntityManagerFactory is created using
> openjpa. Everything looks good until the end when the em.persist call is
> made
>
> 19247 analyticsPU INFO [http-bio-10080-exec-8] openjpa.Runtime -
> Starting OpenJPA 2.2.0
> 19248 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime -
> Properties: javax.persistence.lock.timeout: 0
> javax.persistence.query.timeout: 0
> javax.persistence.sharedCache.mode: UNSPECIFIED
> javax.persistence.validation.group.pre-persist:
> javax.validation.groups.Default
> javax.persistence.validation.group.pre-update:
> javax.validation.groups.Default
> javax.persistence.validation.mode: AUTO
> openjpa.AutoClear: 0
> openjpa.AutoDetach: []
> openjpa.BrokerFactory: jdbc
> openjpa.BrokerImpl: non-finalizing
> openjpa.CacheDistributionPolicy: default
> openjpa.Callbacks: default
> openjpa.ClassResolver:
> org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
> openjpa.Compatibility: default
> openjpa.ConnectionFactoryMode: true
> openjpa.ConnectionRetainMode: 0
> openjpa.DataCache: false
> openjpa.DataCacheManager: default
> openjpa.DataCacheTimeout: -1
> openjpa.DetachState: loaded
> openjpa.DynamicDataStructs: false
> openjpa.DynamicEnhancementAgent: true
> openjpa.EntityManagerFactory: default
> openjpa.FetchBatchSize: -1
> openjpa.FetchGroups: [default]
> openjpa.FlushBeforeQueries: 0
> openjpa.Id: analyticsPU
> openjpa.IgnoreChanges: false
> openjpa.InitializeEagerly: false
> openjpa.InstrumentationManager: default
> openjpa.InverseManager: false
> openjpa.LifecycleEventManager: validating
> openjpa.LockManager: mixed
> openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
> openjpa.ManagedRuntime: auto
> openjpa.MaxFetchDepth: -1
> openjpa.MetaDataFactory:
> jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
> openjpa.MetaDataRepository: default
> openjpa.Multithreaded: false
> openjpa.NontransactionalRead: true
> openjpa.NontransactionalWrite: true
> openjpa.Optimistic: true
> openjpa.OptimizeIdCopy: false
> openjpa.OrphanedKeyAction: log
> openjpa.PostLoadOnMerge: false
> openjpa.ProxyManager: default
> openjpa.QueryCache: false
> openjpa.QueryCompilationCache: true
> openjpa.ReadLockLevel: 10
> openjpa.RefreshFromDataCache: false
> openjpa.RestoreState: 1
> openjpa.RetainState: true
> openjpa.RetryClassRegistration: false
> openjpa.RuntimeUnenhancedClasses: 0
> openjpa.SavepointManager: in-mem
> openjpa.Sequence: table
> openjpa.TransactionMode: true
> openjpa.WriteLockLevel: 20
> openjpa.jdbc.DriverDataSource: auto
> openjpa.jdbc.EagerFetchMode: 2
> openjpa.jdbc.FetchDirection: 1000
> openjpa.jdbc.FinderCache: true
> openjpa.jdbc.IdentifierUtil: default
> openjpa.jdbc.LRSSize: 2
> openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict)
> openjpa.jdbc.QuerySQLCache: true
> openjpa.jdbc.ResultSetType: 1003
> openjpa.jdbc.SQLFactory: default
> openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
> openjpa.jdbc.Schemas: []
> openjpa.jdbc.SubclassFetchMode: 1
> openjpa.jdbc.SynchronizeMappings:
> buildSchema(foreignKeys=true,schemaAction='dropDB,add')
> openjpa.jdbc.TransactionIsolation: -1
> openjpa.jdbc.UpdateManager: default
> 19387 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 19436 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1e2c00f".
> 19439 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 19461 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
> 19787 analyticsPU INFO [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> Using
> dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL
> 5.1.45-community ,MySQL-AB JDBC Driver mysql-connector-java-5.1.6 (
> Revision: ${svn.Revision} )).
> 19809 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> catalogSeparator: .
> catalogTerm: database
> databaseProductName: MySQL
> databaseProductVersion: 5.1.45-community
> driverName: MySQL-AB JDBC Driver
> driverVersion: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
> extraNameCharacters: #@
> identifierQuoteString: `
> numericFunctions:
>
> ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE
> procedureTerm: PROCEDURE
> schemaTerm:
> searchStringEscape: \
> sqlKeywords:
>
> ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,FORCE,FULLTEXT,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,ITERATE,KEYS,KILL,LEAVE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,OPTIMIZE,OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,SCHEMAS,SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VARBINARY,VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL
> stringFunctions:
>
> ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
> systemFunctions:
>
> DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
> timeDateFunctions:
>
> DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
> url:
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
> userName: root@localhost
> defaultTransactionIsolation: 2
> driverMajorVersion: 5
> driverMinorVersion: 1
> maxBinaryLiteralLength: 16777208
> maxCatalogNameLength: 32
> maxCharLiteralLength: 16777208
> maxColumnNameLength: 64
> maxColumnsInGroupBy: 64
> maxColumnsInIndex: 16
> maxColumnsInOrderBy: 64
> maxColumnsInSelect: 256
> maxColumnsInTable: 512
> maxConnections: 0
> maxCursorNameLength: 64
> maxIndexLength: 256
> maxProcedureNameLength: 0
> maxRowSize: 2147483639
> maxSchemaNameLength: 0
> maxStatementLength: 65531
> maxStatements: 0
> maxTableNameLength: 64
> maxTablesInSelect: 256
> maxUserNameLength: 16
> isCatalogAtStart: true
> isReadOnly: false
> nullPlusNonNullIsNull: true
> nullsAreSortedAtEnd: false
> nullsAreSortedAtStart: false
> nullsAreSortedHigh: false
> nullsAreSortedLow: true
> storesLowerCaseIdentifiers: true
> storesLowerCaseQuotedIdentifiers: true
> storesMixedCaseIdentifiers: false
> storesMixedCaseQuotedIdentifiers: false
> storesUpperCaseIdentifiers: false
> storesUpperCaseQuotedIdentifiers: true
> supportsAlterTableWithAddColumn: true
> supportsAlterTableWithDropColumn: true
> supportsANSI92EntryLevelSQL: true
> supportsANSI92FullSQL: false
> supportsANSI92IntermediateSQL: false
> supportsCatalogsInDataManipulation: true
> supportsCatalogsInIndexDefinitions: true
> supportsCatalogsInPrivilegeDefinitions: true
> supportsCatalogsInProcedureCalls: true
> supportsCatalogsInTableDefinitions: true
> supportsColumnAliasing: true
> supportsConvert: false
> supportsCoreSQLGrammar: true
> supportsCorrelatedSubqueries: true
> supportsDataDefinitionAndDataManipulationTransactions: false
> supportsDataManipulationTransactionsOnly: false
> supportsDifferentTableCorrelationNames: true
> supportsExpressionsInOrderBy: true
> supportsExtendedSQLGrammar: false
> supportsFullOuterJoins: false
> supportsGroupBy: true
> supportsGroupByBeyondSelect: true
> supportsGroupByUnrelated: true
> supportsIntegrityEnhancementFacility: false
> supportsLikeEscapeClause: true
> supportsLimitedOuterJoins: true
> supportsMinimumSQLGrammar: true
> supportsMixedCaseIdentifiers: false
> supportsMixedCaseQuotedIdentifiers: false
> supportsMultipleResultSets: false
> supportsMultipleTransactions: true
> supportsNonNullableColumns: true
> supportsOpenCursorsAcrossCommit: false
> supportsOpenCursorsAcrossRollback: false
> supportsOpenStatementsAcrossCommit: false
> supportsOpenStatementsAcrossRollback: false
> supportsOrderByUnrelated: false
> supportsOuterJoins: true
> supportsPositionedDelete: false
> supportsPositionedUpdate: false
> supportsSchemasInDataManipulation: false
> supportsSchemasInIndexDefinitions: false
> supportsSchemasInPrivilegeDefinitions: false
> supportsSchemasInProcedureCalls: false
> supportsSchemasInTableDefinitions: false
> supportsSelectForUpdate: true
> supportsStoredProcedures: true
> supportsSubqueriesInComparisons: true
> supportsSubqueriesInExists: true
> supportsSubqueriesInIns: true
> supportsSubqueriesInQuantifieds: true
> supportsTableCorrelationNames: true
> supportsTransactions: true
> supportsUnion: true
> supportsUnionAll: true
> usesLocalFilePerTable: false
> usesLocalFiles: false
> allProceduresAreCallable: false
> allTablesAreSelectable: false
> dataDefinitionCausesTransactionCommit: true
> dataDefinitionIgnoredInTransactions: false
> doesMaxRowSizeIncludeBlobs: true
> supportsBatchUpdates: true
> 19811 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> Initial connection autoCommit: true, holdability: 2, TransactionIsolation:
> 4
> 19814 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 27724273> [0 ms] close
> 19866 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
> 19868 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 6175440> [1 ms] close
> 19872 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
> DataSource connection setAutoCommit to "false"
> 19882 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
> 21987351, conn 23854573> [0 ms] close
> 19947 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - Found
> datasource 2: datasource 21158020 from config. StoreContext: null
> 19959 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> Scanning directory "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" for
> persistent types.
> 19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Headercontext.class"
> since it is a class, and will not need to be re-parsed later.
> 19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Headercontext].
> 19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Riskcontext.class"
> since it is a class, and will not need to be re-parsed later.
> 20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Riskcontext].
> 20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> Skipping persistent type location association for location
>
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Cookiecontext.class"
> since it is a class, and will not need to be re-parsed later.
> 20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
> of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent
> types
> [com.adaptiveauth.db.jpa.impl.Cookiecontext].
> 20066 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> Scanning resource "META-INF/orm.xml" for persistent types.
> 20067 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - The
> persistent unit root url is
> "file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/"
> 20067 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
> parsePersistentTypeNames() found
> [com.adaptiveauth.db.jpa.impl.Headercontext,
> com.adaptiveauth.db.jpa.impl.Riskcontext,
> com.adaptiveauth.db.jpa.impl.Cookiecontext].
> 20116 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Found
> 3 classes with metadata in 157 milliseconds.
> 20172 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - Found
> datasource1: datasource 25065105 from configuration. StoreContext:
> org.apache.openjpa.kernel.BrokerImpl@8e683a
>
> INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: $Proxy109
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657735.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>
Re: Getting a persistence exception using openjpa jta datasource
Posted by mikespan <mi...@netscape.net>.
Can you provide a link to setup JMX monitoring for configuration. Tried
looking but not sure the correct sample to use.
Here is the complete log trace when a EntityManagerFactory is created using
openjpa. Everything looks good until the end when the em.persist call is
made
19247 analyticsPU INFO [http-bio-10080-exec-8] openjpa.Runtime -
Starting OpenJPA 2.2.0
19248 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime -
Properties: javax.persistence.lock.timeout: 0
javax.persistence.query.timeout: 0
javax.persistence.sharedCache.mode: UNSPECIFIED
javax.persistence.validation.group.pre-persist:
javax.validation.groups.Default
javax.persistence.validation.group.pre-update:
javax.validation.groups.Default
javax.persistence.validation.mode: AUTO
openjpa.AutoClear: 0
openjpa.AutoDetach: []
openjpa.BrokerFactory: jdbc
openjpa.BrokerImpl: non-finalizing
openjpa.CacheDistributionPolicy: default
openjpa.Callbacks: default
openjpa.ClassResolver:
org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
openjpa.Compatibility: default
openjpa.ConnectionFactoryMode: true
openjpa.ConnectionRetainMode: 0
openjpa.DataCache: false
openjpa.DataCacheManager: default
openjpa.DataCacheTimeout: -1
openjpa.DetachState: loaded
openjpa.DynamicDataStructs: false
openjpa.DynamicEnhancementAgent: true
openjpa.EntityManagerFactory: default
openjpa.FetchBatchSize: -1
openjpa.FetchGroups: [default]
openjpa.FlushBeforeQueries: 0
openjpa.Id: analyticsPU
openjpa.IgnoreChanges: false
openjpa.InitializeEagerly: false
openjpa.InstrumentationManager: default
openjpa.InverseManager: false
openjpa.LifecycleEventManager: validating
openjpa.LockManager: mixed
openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
openjpa.ManagedRuntime: auto
openjpa.MaxFetchDepth: -1
openjpa.MetaDataFactory:
jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
openjpa.MetaDataRepository: default
openjpa.Multithreaded: false
openjpa.NontransactionalRead: true
openjpa.NontransactionalWrite: true
openjpa.Optimistic: true
openjpa.OptimizeIdCopy: false
openjpa.OrphanedKeyAction: log
openjpa.PostLoadOnMerge: false
openjpa.ProxyManager: default
openjpa.QueryCache: false
openjpa.QueryCompilationCache: true
openjpa.ReadLockLevel: 10
openjpa.RefreshFromDataCache: false
openjpa.RestoreState: 1
openjpa.RetainState: true
openjpa.RetryClassRegistration: false
openjpa.RuntimeUnenhancedClasses: 0
openjpa.SavepointManager: in-mem
openjpa.Sequence: table
openjpa.TransactionMode: true
openjpa.WriteLockLevel: 20
openjpa.jdbc.DriverDataSource: auto
openjpa.jdbc.EagerFetchMode: 2
openjpa.jdbc.FetchDirection: 1000
openjpa.jdbc.FinderCache: true
openjpa.jdbc.IdentifierUtil: default
openjpa.jdbc.LRSSize: 2
openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
JoinForeignKeyDeleteAction=restrict)
openjpa.jdbc.QuerySQLCache: true
openjpa.jdbc.ResultSetType: 1003
openjpa.jdbc.SQLFactory: default
openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
openjpa.jdbc.Schemas: []
openjpa.jdbc.SubclassFetchMode: 1
openjpa.jdbc.SynchronizeMappings:
buildSchema(foreignKeys=true,schemaAction='dropDB,add')
openjpa.jdbc.TransactionIsolation: -1
openjpa.jdbc.UpdateManager: default
19387 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - No
cache marshaller found for id
org.apache.openjpa.conf.MetaDataCacheMaintenance.
19436 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Using
metadata factory
"org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1e2c00f".
19439 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
OpenJPA will now connect to the database to attempt to determine what type
of database dictionary to use. You may prevent this connection in the future
by setting your openjpa.jdbc.DBDictionary configuration property to the
appropriate value for your database (see the documentation for available
values).
19461 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
19787 analyticsPU INFO [http-bio-10080-exec-8] openjpa.jdbc.JDBC - Using
dictionary class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL
5.1.45-community ,MySQL-AB JDBC Driver mysql-connector-java-5.1.6 (
Revision: ${svn.Revision} )).
19809 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
catalogSeparator: .
catalogTerm: database
databaseProductName: MySQL
databaseProductVersion: 5.1.45-community
driverName: MySQL-AB JDBC Driver
driverVersion: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} )
extraNameCharacters: #@
identifierQuoteString: `
numericFunctions:
ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,SQRT,TAN,TRUNCATE
procedureTerm: PROCEDURE
schemaTerm:
searchStringEscape: \
sqlKeywords:
ACCESSIBLE,ANALYZE,ASENSITIVE,BEFORE,BIGINT,BINARY,BLOB,CALL,CHANGE,CONDITION,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_MINUTE,DAY_SECOND,DELAYED,DETERMINISTIC,DISTINCTROW,DIV,DUAL,EACH,ELSEIF,ENCLOSED,ESCAPED,EXIT,EXPLAIN,FLOAT4,FLOAT8,FORCE,FULLTEXT,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,INFILE,INOUT,INT1,INT2,INT3,INT4,INT8,ITERATE,KEYS,KILL,LEAVE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NO_WRITE_TO_BINLOG,OPTIMIZE,OPTIONALLY,OUT,OUTFILE,PURGE,RANGE,READS,READ_ONLY,READ_WRITE,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RETURN,RLIKE,SCHEMAS,SECOND_MICROSECOND,SENSITIVE,SEPARATOR,SHOW,SPATIAL,SPECIFIC,SQLEXCEPTION,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,STARTING,STRAIGHT_JOIN,TERMINATED,TINYBLOB,TINYINT,TINYTEXT,TRIGGER,UNDO,UNLOCK,UNSIGNED,USE,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VARBINARY,VARCHARACTER,WHILE,X509,XOR,YEAR_MONTH,ZEROFILL
stringFunctions:
ASCII,BIN,BIT_LENGTH,CHAR,CHARACTER_LENGTH,CHAR_LENGTH,CONCAT,CONCAT_WS,CONV,ELT,EXPORT_SET,FIELD,FIND_IN_SET,HEX,INSERT,INSTR,LCASE,LEFT,LENGTH,LOAD_FILE,LOCATE,LOCATE,LOWER,LPAD,LTRIM,MAKE_SET,MATCH,MID,OCT,OCTET_LENGTH,ORD,POSITION,QUOTE,REPEAT,REPLACE,REVERSE,RIGHT,RPAD,RTRIM,SOUNDEX,SPACE,STRCMP,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING,SUBSTRING_INDEX,TRIM,UCASE,UPPER
systemFunctions:
DATABASE,USER,SYSTEM_USER,SESSION_USER,PASSWORD,ENCRYPT,LAST_INSERT_ID,VERSION
timeDateFunctions:
DAYOFWEEK,WEEKDAY,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,PERIOD_ADD,PERIOD_DIFF,TO_DAYS,FROM_DAYS,DATE_FORMAT,TIME_FORMAT,CURDATE,CURRENT_DATE,CURTIME,CURRENT_TIME,NOW,SYSDATE,CURRENT_TIMESTAMP,UNIX_TIMESTAMP,FROM_UNIXTIME,SEC_TO_TIME,TIME_TO_SEC
url: jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
userName: root@localhost
defaultTransactionIsolation: 2
driverMajorVersion: 5
driverMinorVersion: 1
maxBinaryLiteralLength: 16777208
maxCatalogNameLength: 32
maxCharLiteralLength: 16777208
maxColumnNameLength: 64
maxColumnsInGroupBy: 64
maxColumnsInIndex: 16
maxColumnsInOrderBy: 64
maxColumnsInSelect: 256
maxColumnsInTable: 512
maxConnections: 0
maxCursorNameLength: 64
maxIndexLength: 256
maxProcedureNameLength: 0
maxRowSize: 2147483639
maxSchemaNameLength: 0
maxStatementLength: 65531
maxStatements: 0
maxTableNameLength: 64
maxTablesInSelect: 256
maxUserNameLength: 16
isCatalogAtStart: true
isReadOnly: false
nullPlusNonNullIsNull: true
nullsAreSortedAtEnd: false
nullsAreSortedAtStart: false
nullsAreSortedHigh: false
nullsAreSortedLow: true
storesLowerCaseIdentifiers: true
storesLowerCaseQuotedIdentifiers: true
storesMixedCaseIdentifiers: false
storesMixedCaseQuotedIdentifiers: false
storesUpperCaseIdentifiers: false
storesUpperCaseQuotedIdentifiers: true
supportsAlterTableWithAddColumn: true
supportsAlterTableWithDropColumn: true
supportsANSI92EntryLevelSQL: true
supportsANSI92FullSQL: false
supportsANSI92IntermediateSQL: false
supportsCatalogsInDataManipulation: true
supportsCatalogsInIndexDefinitions: true
supportsCatalogsInPrivilegeDefinitions: true
supportsCatalogsInProcedureCalls: true
supportsCatalogsInTableDefinitions: true
supportsColumnAliasing: true
supportsConvert: false
supportsCoreSQLGrammar: true
supportsCorrelatedSubqueries: true
supportsDataDefinitionAndDataManipulationTransactions: false
supportsDataManipulationTransactionsOnly: false
supportsDifferentTableCorrelationNames: true
supportsExpressionsInOrderBy: true
supportsExtendedSQLGrammar: false
supportsFullOuterJoins: false
supportsGroupBy: true
supportsGroupByBeyondSelect: true
supportsGroupByUnrelated: true
supportsIntegrityEnhancementFacility: false
supportsLikeEscapeClause: true
supportsLimitedOuterJoins: true
supportsMinimumSQLGrammar: true
supportsMixedCaseIdentifiers: false
supportsMixedCaseQuotedIdentifiers: false
supportsMultipleResultSets: false
supportsMultipleTransactions: true
supportsNonNullableColumns: true
supportsOpenCursorsAcrossCommit: false
supportsOpenCursorsAcrossRollback: false
supportsOpenStatementsAcrossCommit: false
supportsOpenStatementsAcrossRollback: false
supportsOrderByUnrelated: false
supportsOuterJoins: true
supportsPositionedDelete: false
supportsPositionedUpdate: false
supportsSchemasInDataManipulation: false
supportsSchemasInIndexDefinitions: false
supportsSchemasInPrivilegeDefinitions: false
supportsSchemasInProcedureCalls: false
supportsSchemasInTableDefinitions: false
supportsSelectForUpdate: true
supportsStoredProcedures: true
supportsSubqueriesInComparisons: true
supportsSubqueriesInExists: true
supportsSubqueriesInIns: true
supportsSubqueriesInQuantifieds: true
supportsTableCorrelationNames: true
supportsTransactions: true
supportsUnion: true
supportsUnionAll: true
usesLocalFilePerTable: false
usesLocalFiles: false
allProceduresAreCallable: false
allTablesAreSelectable: false
dataDefinitionCausesTransactionCommit: true
dataDefinitionIgnoredInTransactions: false
doesMaxRowSizeIncludeBlobs: true
supportsBatchUpdates: true
19811 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
Initial connection autoCommit: true, holdability: 2, TransactionIsolation: 4
19814 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 27724273> [0 ms] close
19866 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
createConnectionFactory:
DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@17e7691
19868 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 6175440> [1 ms] close
19872 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC -
DataSource connection setAutoCommit to "false"
19882 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.jdbc.JDBC - <t
21987351, conn 23854573> [0 ms] close
19947 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - Found
datasource 2: datasource 21158020 from config. StoreContext: null
19959 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
Scanning directory "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" for
persistent types.
19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Headercontext.class"
since it is a class, and will not need to be re-parsed later.
19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Headercontext].
19968 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Riskcontext.class"
since it is a class, and will not need to be re-parsed later.
20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Riskcontext].
20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
Skipping persistent type location association for location
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/com/adaptiveauth/db/jpa/impl/Cookiecontext.class"
since it is a class, and will not need to be re-parsed later.
20016 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Scan
of "C:\opt\tomcat7\webapps\analytics\WEB-INF\classes" found persistent types
[com.adaptiveauth.db.jpa.impl.Cookiecontext].
20066 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
Scanning resource "META-INF/orm.xml" for persistent types.
20067 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - The
persistent unit root url is
"file:/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/"
20067 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData -
parsePersistentTypeNames() found
[com.adaptiveauth.db.jpa.impl.Headercontext,
com.adaptiveauth.db.jpa.impl.Riskcontext,
com.adaptiveauth.db.jpa.impl.Cookiecontext].
20116 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.MetaData - Found
3 classes with metadata in 157 milliseconds.
20172 analyticsPU TRACE [http-bio-10080-exec-8] openjpa.Runtime - Found
datasource1: datasource 25065105 from configuration. StoreContext:
org.apache.openjpa.kernel.BrokerImpl@8e683a
INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: $Proxy109
--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657735.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Getting a persistence exception using openjpa jta datasource
Posted by Romain Manni-Bucau <rm...@gmail.com>.
please share more logs or even a sample reproducing it otherwise that's
pretty impossible to help you
FYI you should be able to valid your config through JMX
*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*
2012/10/1 mikespan <mi...@netscape.net>
> Thanks for the reply. Got further along following conventions my tomee.xml
> now looks like
>
> <Resource id="jdbc/mysql" type="javax.sql.DataSource">
> # configure the pool
> DataSourceCreator tomcat
> # it is a jta datasource
> JtaManaged true
> # tomcat pool configuration
> JdbcDriver com.mysql.jdbc.Driver
> JdbcUrl
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
> UserName root
> Password adminl8g3e7
> ValidationQuery SELECT 1
> MaxActive 4
> MaxIdle 2
> MaxWait -1
> JmxEnabled true # specific to tomcat pooling
> </Resource>
>
>
> But getting new error.
> INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: $Proxy109
>
> Don't know what Proxy109 means
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657733.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>
Re: Getting a persistence exception using openjpa jta datasource
Posted by mikespan <mi...@netscape.net>.
Thanks for the reply. Got further along following conventions my tomee.xml
now looks like
<Resource id="jdbc/mysql" type="javax.sql.DataSource">
# configure the pool
DataSourceCreator tomcat
# it is a jta datasource
JtaManaged true
# tomcat pool configuration
JdbcDriver com.mysql.jdbc.Driver
JdbcUrl
jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
UserName root
Password adminl8g3e7
ValidationQuery SELECT 1
MaxActive 4
MaxIdle 2
MaxWait -1
JmxEnabled true # specific to tomcat pooling
</Resource>
But getting new error.
INFO: <openjpa-2.2.0-r422266:1244990 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: $Proxy109
Don't know what Proxy109 means
--
View this message in context: http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731p4657733.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
Re: Getting a persistence exception using openjpa jta datasource
Posted by Romain Manni-Bucau <rm...@gmail.com>.
Hi,
can you try adding UserName please? (respecting the case)
*Romain Manni-Bucau*
*Twitter: @rmannibucau <https://twitter.com/rmannibucau>*
*Blog: **http://rmannibucau.wordpress.com/*<http://rmannibucau.wordpress.com/>
*LinkedIn: **http://fr.linkedin.com/in/rmannibucau*
*Github: https://github.com/rmannibucau*
2012/10/1 mikespan <mi...@netscape.net>
> I'm getting the following exception when trying to persist data using a jta
> configured data source
>
> <openjpa-2.2.0-r422266:1244990 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: invalid authorization
> specification - not found: root
>
> My datasource is listed in tomee.xml
>
> <Resource id="jdbc/mysql" type="javax.sql.DataSource">
> # configure the pool
> DataSourceCreator = tomcat
> # it is a jta datasource
> JtaManaged = true
> # tomcat pool configuration
> driverClassName = com.mysql.jdbc.Driver
> url =
> jdbc:mysql://localhost:3306/adaptiveauth?noAccessToProcedureBodies=true
> username = root
> password = *******
> validationQuery = SELECT 1
> maxActive=4
> maxIdle=2
> maxWait=-1
> jmxEnabled = true # specific to tomcat pooling
> </Resource>
>
> My persistence.xml is
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
> <persistence-unit name="analyticsPU" transaction-type="JTA">
> <jta-data-source>jdbc/mysql</jta-data-source>
> <properties>
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(foreignKeys=true,schemaAction='dropDB,add')"/>
> <property name="openjpa.jdbc.SchemaFactory"
> value="native(foreignKeys=true)" />
> <property name="openjpa.jdbc.MappingDefaults"
> value="ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict"/>
> <property name="openjpa.Log" value="DefaultLevel=TRACE,SQL=TRACE"
> />
> </properties>
> </persistence-unit>
> </persistence>
>
> My web.xml has
>
> <persistence-unit-ref>
>
> <persistence-unit-ref-name>persistence-factory</persistence-unit-ref-name>
> <persistence-unit-name>analyticsPU</persistence-unit-name>
> </persistence-unit-ref>
>
>
> Code to create EntityManagerFactory
>
> return (EntityManagerFactory) new
> InitialContext().lookup("java:comp/env/persistence-factory");
>
> Below is the log trace for openjpa when trying to open a connection
>
>
> 13776 analyticsPU INFO [http-bio-10080-exec-1] openjpa.Runtime -
> Starting OpenJPA 2.2.0
> 13777 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime -
> Properties: javax.persistence.lock.timeout: 0
> javax.persistence.query.timeout: 0
> javax.persistence.sharedCache.mode: UNSPECIFIED
> javax.persistence.validation.group.pre-persist:
> javax.validation.groups.Default
> javax.persistence.validation.group.pre-update:
> javax.validation.groups.Default
> javax.persistence.validation.mode: AUTO
> openjpa.AutoClear: 0
> openjpa.AutoDetach: []
> openjpa.BrokerFactory: jdbc
> openjpa.BrokerImpl: non-finalizing
> openjpa.CacheDistributionPolicy: default
> openjpa.Callbacks: default
> openjpa.ClassResolver:
> org.apache.openjpa.persistence.PersistenceUnitInfoImpl$ClassResolverImpl
> openjpa.Compatibility: default
> openjpa.ConnectionFactoryMode: true
> openjpa.ConnectionRetainMode: 0
> openjpa.DataCache: false
> openjpa.DataCacheManager: default
> openjpa.DataCacheTimeout: -1
> openjpa.DetachState: loaded
> openjpa.DynamicDataStructs: false
> openjpa.DynamicEnhancementAgent: true
> openjpa.EntityManagerFactory: default
> openjpa.FetchBatchSize: -1
> openjpa.FetchGroups: [default]
> openjpa.FlushBeforeQueries: 0
> openjpa.Id: analyticsPU
> openjpa.IgnoreChanges: false
> openjpa.InitializeEagerly: false
> openjpa.InstrumentationManager: default
> openjpa.InverseManager: false
> openjpa.LifecycleEventManager: validating
> openjpa.LockManager: mixed
> openjpa.Log: true(DefaultLevel=TRACE,SQL=TRACE)
> openjpa.ManagedRuntime: auto
> openjpa.MaxFetchDepth: -1
> openjpa.MetaDataFactory:
> jpa(Files=/C:/opt/tomcat7/webapps/analytics/WEB-INF/classes/)
> openjpa.MetaDataRepository: default
> openjpa.Multithreaded: false
> openjpa.NontransactionalRead: true
> openjpa.NontransactionalWrite: true
> openjpa.Optimistic: true
> openjpa.OptimizeIdCopy: false
> openjpa.OrphanedKeyAction: log
> openjpa.PostLoadOnMerge: false
> openjpa.ProxyManager: default
> openjpa.QueryCache: false
> openjpa.QueryCompilationCache: true
> openjpa.ReadLockLevel: 10
> openjpa.RefreshFromDataCache: false
> openjpa.RestoreState: 1
> openjpa.RetainState: true
> openjpa.RetryClassRegistration: false
> openjpa.RuntimeUnenhancedClasses: 0
> openjpa.SavepointManager: in-mem
> openjpa.Sequence: table
> openjpa.TransactionMode: true
> openjpa.WriteLockLevel: 20
> openjpa.jdbc.DriverDataSource: auto
> openjpa.jdbc.EagerFetchMode: 2
> openjpa.jdbc.FetchDirection: 1000
> openjpa.jdbc.FinderCache: true
> openjpa.jdbc.IdentifierUtil: default
> openjpa.jdbc.LRSSize: 2
> openjpa.jdbc.MappingDefaults: jpa(ForeignKeyDeleteAction=restrict,
> JoinForeignKeyDeleteAction=restrict)
> openjpa.jdbc.QuerySQLCache: true
> openjpa.jdbc.ResultSetType: 1003
> openjpa.jdbc.SQLFactory: default
> openjpa.jdbc.SchemaFactory: native(foreignKeys=true)
> openjpa.jdbc.Schemas: []
> openjpa.jdbc.SubclassFetchMode: 1
> openjpa.jdbc.SynchronizeMappings:
> buildSchema(foreignKeys=true,schemaAction='dropDB,add')
> openjpa.jdbc.TransactionIsolation: -1
> openjpa.jdbc.UpdateManager: default
> 13814 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 13903 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1da817b".
> 13907 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 13921 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
> Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
> INFO: checkpointClose start
> Oct 1, 2012 10:44:46 AM org.hsqldb.persist.Logger logInfoEvent
> INFO: checkpointClose end
> 14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.Runtime - No
> cache marshaller found for id
> org.apache.openjpa.conf.MetaDataCacheMaintenance.
> 14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.MetaData - Using
> metadata factory
> "org.apache.openjpa.persistence.jdbc.PersistenceMappingFactory@1613fe7".
> 14503 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> OpenJPA will now connect to the database to attempt to determine what type
> of database dictionary to use. You may prevent this connection in the
> future
> by setting your openjpa.jdbc.DBDictionary configuration property to the
> appropriate value for your database (see the documentation for available
> values).
> 14523 analyticsPU TRACE [http-bio-10080-exec-1] openjpa.jdbc.JDBC -
> createConnectionFactory:
>
> DataSource:org.apache.openejb.resource.jdbc.managed.local.ManagedDataSource@121f653
> Oct 1, 2012 10:44:46 AM
> com.adaptiveauth.rest.server.resources.InspectionResourceBase
> postInspection
> INFO: <openjpa-2.2.0-r422266:1244990 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: invalid authorization
> specification - not found: root
>
>
> Don't know what kind of authorization is required for my user 'root' since
> that user has all privileges on the database.
>
>
>
>
> --
> View this message in context:
> http://openejb.979440.n4.nabble.com/Getting-a-persistence-exception-using-openjpa-jta-datasource-tp4657731.html
> Sent from the OpenEJB Dev mailing list archive at Nabble.com.
>