[Benerator] Message d'erreur

**geforce** · 12/07/2014, 23h45

Allo, j'ai fait l'exemple du Tutorial http://arodrigues.developpez.com/tut...nce/benerator/
pour la section VII-B. pour l'application YAPS fourni avec le livre "Java EE 5" d'Antonio Goncalves.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
<?xml version="1.0" encoding="iso-8859-1"?>
<setup 	xmlns="http://databene.org/benerator/0.6.3"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xsi:schemaLocation="http://databene.org/benerator/0.6.3 http://databene.org/benerator-0.6.3.xsd">
 
    <import defaults  = "true"
		domains   = "person,net,address,finance"
		platforms = "db"/>
 
    <database id="db" url="jdbc:postgresql://localhost:5432/postgres" driver="org.postgresql.Driver" user="postgres" password="*****" schema="public"/>
 
    <execute uri="drop_tables.sql" target="db" onError="ignore"/>
    <execute uri="create_tables.sql" target="db" optimize="true"/>
 
    <iterate source="category.import.csv" type="T_CATEGORY" encoding="utf-8" consumer="db" />
    <iterate source="product.import.csv" type="T_PRODUCT" encoding="utf-8" consumer="db" />
    <iterate source="item.import.csv" type="T_ITEM" encoding="utf-8" consumer="db" /> 
 
 
<generate type="T_ADDRESS" count="1000" consumer="db">
<variable name="adresse" generator="org.databene.domain.address.AddressGenerator" />
	<id name="id" generator="idGen" />
	<attribute name="street1" script="adresse.street" />
	<attribute name="city" script="adresse.city" />
	<attribute name="state" script="adresse.state" />
	<attribute name="zip_code" script="adresse.postalCode" />
	<attribute name="country" script="adresse.country" />
</generate>
 
<generate type="T_CUSTOMER" count="1000" consumer="db">
<variable name="individu" generator="org.databene.domain.person.PersonGenerator" dataset="FR" locale="fr"/>
<variable name="adresse" generator="org.databene.domain.address.AddressGenerator" />
	<id name="id" generator="idGen" />
	<attribute name="login" script="individu.givenName" />
	<attribute name="password" pattern="[A-Za-z0-9]{8,12}" />
	<attribute name="firstname" script="individu.givenName" />
	<attribute name="lastname" script="individu.familyName" />
	<attribute name="telephone" script="adresse.mobilePhone" />
	<attribute name="email" script="individu.email" />
	<attribute name="date_of_birth" script="individu.birthDate" />
	<attribute name="address_fk" source="db" selector="select id from T_ADDRESS" cyclic="true" />
</generate>             
 
</setup>

Le message d'erreur:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
>benerator shop.xml
Local classpath: .;E:\databene-benerator-0.9.5\bin;E:\databene-benerator-0.9.5\lib\*
17:36:12,901 INFO  (main) [CONFIG] Running file shop.xml
17:36:12,904 INFO  (main) [CONFIG] Benerator 0.9.5 build 2538
17:36:12,905 INFO  (main) [CONFIG] Java version 1.7.0_15
17:36:12,905 INFO  (main) [CONFIG] JVM Java HotSpot(TM) Client VM 23.7-b01 (Oracle Corporation)
17:36:12,905 INFO  (main) [CONFIG] OS Windows 7 6.1 (x86)
17:36:12,905 INFO  (main) [CONFIG] Installed JSR 223 Script Engines:
17:36:12,909 INFO  (main) [CONFIG] - Mozilla Rhino[js, rhino, JavaScript, javascript, ECMAScript, ecmascript]
17:36:12,910 INFO  (main) [CONFIG] Configured heap size limit: 247 MB
17:36:13,420 INFO  (main) [EvaluateStatement] Executing script drop_tables.sql
17:36:13,619 INFO  (main) [JDBC] Connected to PostgreSQL 9.3.4
17:36:13,620 INFO  (main) [JDBC] Using driver PostgreSQL Native Driver PostgreSQL 8.4 JDBC4 (build 701)
17:36:13,620 INFO  (main) [JDBC] JDBC version 4.0
17:36:13,686 INFO  (main) [EvaluateStatement] Executing script create_tables.sql
 
17:36:14,103 INFO  (main) [JDBCDBImporter] Importing tables from environment '___temp'
17:36:14,120 INFO  (main) [DefaultDBSystem] Fetching table details and orderingtables by dependency
17:36:14,503 INFO  (main) [TaskExecutor] Running task StateTrackingTaskProxy[GenerateAndConsumeTask(t_category)]
17:36:14,584 ERROR (main) [DescriptorRunner] Error in Benerator executionorg.databene.commons.ConfigurationError: Catalog 'null' not found in database 'db'
        at org.databene.platform.db.DBSystem.findTableInConfiguredCatalogAndSchema(DBSystem.java:819)
        at org.databene.platform.db.DBSystem.getTable(DBSystem.java:791)
        at org.databene.platform.db.DBSystem.getWriteColumnInfos(DBSystem.java:744)
        at org.databene.platform.db.DBSystem.persistOrUpdate(DBSystem.java:831)
        at org.databene.platform.db.DBSystem.store(DBSystem.java:360)
        at org.databene.benerator.storage.StorageSystemInserter.startProductConsumption(StorageSystemInserter.java:53)
        at org.databene.benerator.consumer.AbstractConsumer.startConsuming(AbstractConsumer.java:47)
        at org.databene.benerator.consumer.ConsumerProxy.startConsuming(ConsumerProxy.java:62)
        at org.databene.benerator.engine.statement.ConsumptionStatement.execute(ConsumptionStatement.java:53)
        at org.databene.benerator.engine.statement.GenerateAndConsumeTask.execute(GenerateAndConsumeTask.java:159)
        at org.databene.task.TaskProxy.execute(TaskProxy.java:59)
        at org.databene.task.StateTrackingTaskProxy.execute(StateTrackingTaskProxy.java:52)
        at org.databene.task.TaskExecutor.runWithoutPage(TaskExecutor.java:136)
        at org.databene.task.TaskExecutor.runPage(TaskExecutor.java:126)
        at org.databene.task.TaskExecutor.run(TaskExecutor.java:101)
        at org.databene.task.TaskExecutor.run(TaskExecutor.java:77)
        at org.databene.task.TaskExecutor.execute(TaskExecutor.java:71)
        at org.databene.benerator.engine.statement.GenerateOrIterateStatement.executeTask(GenerateOrIterateStatement.java:156)
        at org.databene.benerator.engine.statement.GenerateOrIterateStatement.execute(GenerateOrIterateStatement.java:99)
        at org.databene.benerator.engine.statement.LazyStatement.execute(LazyStatement.java:58)
        at org.databene.benerator.engine.statement.StatementProxy.execute(StatementProxy.java:46)
        at org.databene.benerator.engine.statement.TimedGeneratorStatement.execute(TimedGeneratorStatement.java:70)
        at org.databene.benerator.engine.statement.SequentialStatement.executeSubStatements(SequentialStatement.java:52)
        at org.databene.benerator.engine.statement.SequentialStatement.execute(SequentialStatement.java:47)
        at org.databene.benerator.engine.BeneratorRootStatement.execute(BeneratorRootStatement.java:63)
        at org.databene.benerator.engine.DescriptorRunner.execute(DescriptorRunner.java:127)
        at org.databene.benerator.engine.DescriptorRunner.runWithoutShutdownHook(DescriptorRunner.java:109)
        at org.databene.benerator.engine.DescriptorRunner.run(DescriptorRunner.java:102)
        at org.databene.benerator.main.Benerator.runFile(Benerator.java:94)
        at org.databene.benerator.main.Benerator.runFromCommandLine(Benerator.java:75)
        at org.databene.benerator.main.Benerator.main(Benerator.java:68)
17:36:14,600 INFO  (main) [CachingDBImporter] Exporting Database meta data of ___temp to cache file
17:36:14,643 INFO  (main) [CONFIG] Max. committed heap size: 15 MB

Quelqu'un pourrai déblocage ou me faire comprendre c'est que "Error in Benerator executionorg.databene.commons.ConfigurationError: Catalog 'null' not found in database 'db'"

Merci

**geforce** · 24/07/2014, 00h34

Je me rends compte que l'importation CSV qui cause problème avec les balises <iterate>

Quelqu'un a t'il une explication ? Ou un paramétré que je dois ajouter.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
<iterate source="category.import.csv" type="T_CATEGORY" encoding="utf-8" consumer="db" >
    	<id name="id" type="long" />
	<attribute name="name" type="string" script="T_CATEGORY.name" />
        <attribute name="description" type="string" script="T_CATEGORY.description" />
</iterate>
<iterate source="product.import.csv" type="T_PRODUCT" encoding="utf-8" >
    	<id name="id" type="long" />
	<attribute name="name" type="string" script="T_PRODUCT.name" />
        <attribute name="description" type="string" script="T_PRODUCT.description" />    
</iterate>
<iterate source="item.import.csv" type="T_ITEM" encoding="utf-8"  > 
    	<id name="id" type="long" />
	<attribute name="name" type="string" script="T_ITEM.name" />
        <attribute name="unit_cost" type="int" script="T_ITEM.unit_cost" />
        <attribute name="unit_cost" type="string" script="T_ITEM.unit_cost" />
</iterate>

NB: j'utilise Benerator-0.9.5

[Benerator] Message d'erreur

Tests et Performance Java

Discussions similaires

Partager

Partager